<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <link rel="canonical" href="https://blog.csdn.net/redbloodbody/article/details/58185240"/>
    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    <meta name="renderer" content="webkit"/>
    <meta name="force-rendering" content="webkit"/>
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <meta name="report" content='{"pid":"blog"}'>
    <meta name="referrer" content="always">
    <meta http-equiv="Cache-Control" content="no-siteapp" /><link rel="alternate" media="handheld" href="#" />
    <meta name="shenma-site-verification" content="5a59773ab8077d4a62bf469ab966a63b_1497598848">
        <meta name="csdn-baidu-search"  content='{"autorun":true,"install":true,"keyword":"mysql介绍（myisam） - RedBloodyBodys Blog"}'>
    
    <link href="https://csdnimg.cn/public/favicon.ico" rel="SHORTCUT ICON">
    <title>mysql介绍（myisam） - RedBloodyBody's Blog - CSDN博客</title>

        
                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/detail-3c56c08d12.min.css">
            
            <script type="application/ld+json">{"@context":"https:\/\/ziyuan.baidu.com\/contexts\/cambrian.jsonld","@id":"https:\/\/blog.csdn.net\/redbloodbody\/article\/details\/58185240","appid":"1563894916825412","title":"mysql\u4ecb\u7ecd\uff08myisam\uff09 - RedBloodyBody's Blog","images":["https:\/\/img-blog.csdn.net\/20170227180209481?watermark\/2\/text\/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvcmVkYmxvb2Rib2R5\/font\/5a6L5L2T\/fontsize\/400\/fill\/I0JBQkFCMA==\/dissolve\/70\/gravity\/SouthEast"],"pubDate":"2019-08-09T15:10:07"}</script>
        
            <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-9b39979775.min.css">
        <script type="text/javascript">
        var username = "u010672439";
        var blog_address = "https://blog.csdn.net/redbloodbody";
        var static_host = "https://csdnimg.cn/release/phoenix/";
        var currentUserName = "";
        var isShowAds = true;
        var isOwner = false;
        var loginUrl = "http://passport.csdn.net/account/login?from=https://blog.csdn.net/redbloodbody/article/details/58185240"
        var blogUrl = "https://blog.csdn.net/";

        var curSkin = "skin3-template";
        // 收藏所需数据
        var articleTitle = "mysql介绍（myisam）";
        var articleDesc = "mysql引擎常用的mysql引擎有myisam、innodb。很多人不知道还有Memery,Archive,Ndb等在这里详细介绍myisam的特性下表是MyISAM的功能每个myisam表都有三个文件：.frm(储存表结构).myd（储存数据）.myi（储存索引）在MySQL5.7,默认引擎是innodb，如果要使用myisam，需要指定engine=myisam。";
        // 第四范式所需数据
        var articleTitles = "mysql介绍（myisam） - RedBloodyBodys Blog";
        
        var nickName = "RedBloodyBody";
        var isCorporate = false;
        var subDomainBlogUrl = "https://blog.csdn.net/"
        var digg_base_url = "https://blog.csdn.net/redbloodbody/phoenix/comment";
        var articleDetailUrl = "https://blog.csdn.net/u010672439/article/details/58185240";
    </script>
    <script src="https://csdnimg.cn/public/common/libs/jquery/jquery-1.9.1.min.js" type="text/javascript"></script>
    <script src="//g.csdnimg.cn/??fixed-sidebar/1.1.3/fixed-sidebar.js,report/1.0.4/report.js" type="text/javascript"></script>
    <link rel="stylesheet" href="https://csdnimg.cn/public/sandalstrap/1.4/css/sandalstrap.min.css">
    <style>
        .MathJax, .MathJax_Message, .MathJax_Preview{
            display: none
        }
    </style>
</head>
<body class="nodata " > 
    <link rel="stylesheet" href="https://csdnimg.cn/public/common/toolbar/content_toolbar_css/content_toolbar.css">
    <script id="toolbar-tpl-scriptId" src="https://csdnimg.cn/public/common/toolbar/js/content_toolbar.js" type="text/javascript" domain="https://blog.csdn.net/"></script>
<div id="kp_box_476" data-pid="476" data-track-view='{"mod":"kp_popu_476-1490","con":",,"}' data-track-click='{"mod":"kp_popu_476-1490","con":",,"}' data-report-view='{"mod":"kp_popu_476-1490","keyword":""}' data-report-click='{"mod":"kp_popu_476-1490","keyword":""}'><script src="//csdnimg.cn/public/common/indexSuperise/1.1.1/indexSuperise.js?20190111165312"></script><script>window.csdn.indexSuperise({smallMoveImg:'https://img-bss.csdn.net/1565248701607.jpg',bigMoveImg:'https://img-bss.csdn.net/1565248693537.jpg',link:'https://kunyu.csdn.net?p=476&a=1490&c=652&k=&d=1&t=3&dest=https%3A%2F%2Fdeveloper.huaweicloud.com%2Fcompetition%2Fcompetitions%2F1000007620%2Fintroduction%3Futm_source%3Dcsdn%26utm_medium%3Dpr%26utm_campaign%3Dcsdntf%26utm_term%3Dgarbage',trackSuperId:476,smallMove:'notMove',trackSId:1490});</script></div><link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/blog_code-c3a0c33d5c.css">
<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-e040f0c7c8.css">

<script type="text/javascript">
	var NEWS_FEED = function(){}
</script>

<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/chart-3456820cac.css" />
<div class="container clearfix" id="mainBox">
			<div class="recommend-right">
  <ul class="recommend-fixed-box">
    
  </ul>
</div>	    <main>
        <div class="blog-content-box">
    <div class="article-header-box">
        <div class="article-header">
            <div class="article-title-box">
                <span class="article-type type-1 float-left">原</span>                <h1 class="title-article">mysql介绍（myisam）</h1>
            </div>
            <div class="article-info-box">
                <div class="article-bar-top">
                                                                                                                                            <span class="time">2017年02月27日 18:38:14</span>
                    <a class="follow-nickName" href="https://me.csdn.net/u010672439" target="_blank">RedBloodyBody</a>
                    <span class="read-count">阅读数 3417</span>
                                                                                                                                </div>
                <div class="operating">
                                    </div>
            </div>
        </div>
    </div>
    <article class="baidu_pl">
                <div id="article_content" class="article_content clearfix">
                                                <div class="article-copyright">
                                                    <svg class="icon" title="CSDN认证原创" aria-hidden="true"
                                 style="width:53px; height: 18px; vertical-align: -4px;">
                                <use xlink:href="#CSDN_Cert"></use>
                            </svg>
                        
                        版权声明：本文为博主原创文章，未经博主允许不得转载。                        <a class="copy-right-url" href=" https://blog.csdn.net/u010672439/article/details/58185240"> https://blog.csdn.net/u010672439/article/details/58185240</a>
                    </div>
                                                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                                        <div id="content_views" class="markdown_views prism-atom-one-dark">
                    <!-- flowchart 箭头图标 勿删 -->
                    <svg xmlns="http://www.w3.org/2000/svg" style="display: none;">
                        <path stroke-linecap="round" d="M5,0 0,2.5 5,5z" id="raphael-marker-block" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"></path>
                    </svg>
                                            <dl>
<dt>mysql引擎</dt>
<dd>
<p>常用的mysql引擎有myisam、innodb。很多人不知道还有 Memery ,Archive,Ndb等</p>
</dd>
</dl>

<p>在这里详细介绍myisam的特性 <br>
下表是MyISAM 的功能 <br>
<img src="https://img-blog.csdn.net/20170227180209481?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvcmVkYmxvb2Rib2R5/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="这里写图片描述" title=""></p>

<p>每个myisam表都有三个文件：.frm(储存表结构) .myd（储存数据） .myi（储存索引） <br>
在 MySQL 5.7,默认引擎是innodb，如果要使用myisam，需要指定 engine=myisam。</p>



<dl>
<dt>myisam具有如下特点：</dt>
<dd>
<p>1、所有数据值都以低字节优先存储。 这使得数据机和操作系统独立。 二进制可移植性的唯一要求是，机器使用二进制补码有符号整数和IEEE浮点格式。 这些要求广泛应用于主流机器。 二进制兼容性可能不适用于嵌入式系统，有时具有特殊的处理器。存储数据低字节优先没有显着的速度代价; 表行中的字节通常是不对齐的，并且按顺序读取未对齐字节比按相反顺序进行更少的处理。 此外，服务器中提取列值的代码与其他代码相比不是时间关键的。</p>
</dd>

<dd>2、 所有数字键值都以高字节先存储，以允许更好的索引压缩。</dd>

<dd>3、支持大文件的文件系统（最多63位文件长度）。</dd>

<dd>4、在MyISAM表中有 (2^32)^2（1.844E + 19）行的限制。</dd>

<dd>5、每个MyISAM表的最大索引数为64。每个索引的列数上限为16。</dd>

<dd>6、当按照排序顺序插入行时（如使用AUTO_INCREMENT列时），索引树被拆分，以便高节点只包含一个键。 这提高了索引树中的空间利用率。</dd>

<dd>7、支持每个表一个AUTO_INCREMENT列的内部处理。 MyISAM自动更新此列以进行INSERT和UPDATE操作。 这使AUTO_INCREMENT列更快（至少10％）。 序列顶部的值在删除后不会重复使用。 （当AUTO_INCREMENT列被定义为多列索引的最后一列时，将重复使用从序列顶部删除的值。）AUTO_INCREMENT值可以使用ALTER TABLE或myisamchk重置。</dd>

<dd>8、 当使用更新、删除和插入混合操作时，动态大小的行的碎片要少得多。 这是通过自动组合相邻的已删除块以及通过扩展块（如果删除下一个块）来完成的。</dd>

<dd>9、 MyISAM支持并发插入：如果表在数据文件中间没有可用块，则可以在其他线程从表中读取的同时，向其中插入新行。 由于删除行或更新具有比当前内容更多的数据的动态长度行，可能会发生空闲块。 当所有空闲块都用尽（填充）时，将来的插入将再次变为并行。</dd>

<dd>10 、可以将数据文件和索引文件放在不同物理设备上的不同目录中，以获得更高的速度，使用DATA DIRECTORY和INDEX DIRECTORY表选项到CREATE TABLE。</dd>

<dd>11 、 BLOB和TEXT列可以建立索引。</dd>

<dd>12 、索引列中允许NULL值。 每个键需要0到1个字节。</dd>

<dd>13 、每个字符列可以有不同的字符集。</dd>

<dd>14 、在MyISAM索引文件中有一个标志，指示表是否正确关闭。 如果mysqld使用–myisam-recover-options选项启动，则MyISAM表在打开时会自动检查，如果表未正确关闭，则会进行修复。</dd>

<dd>15、 myisamchk –analyze存储键的部分以及整个键的统计信息。</dd>

<dd>16、 myisampack可以包装BLOB和VARCHAR列。</dd>

<dd>17、 支持一个真正的VARCHAR类型; 一个VARCHAR列以一个或两个字节存储的长度开始。</dd>

<dd>18、 具有VARCHAR列的表可以具有固定或动态行长度。</dd>

<dd>19、 表中VARCHAR和CHAR列的长度总和可能高达64KB。</dd>

<dd>20、 任意长度UNIQUE约束。</dd>
</dl>



<h1 id="myisam表存储格式">MyISAM表存储格式</h1>

<p>MyISAM支持三种不同的存储格式。 其中两个，固定和动态格式，根据您使用的列的类型自动选择。 第三种压缩格式只能使用myisampack实用程序创建 <br>
对没有BLOB或TEXT列的表使用CREATE TABLE或ALTER TABLE时，可以使用ROW_FORMAT表选项将表格格式强制为FIXED或DYNAMIC。</p>

<dl>
<dt>静态（固定长度）表特性</dt>
<dd>1 静态格式是MyISAM表的默认值。 当表不包含可变长度列（VARCHAR，VARBINARY，BLOB或TEXT）时使用。 每行使用固定数量的字节存储。</dd>

<dd>2 在三种MyISAM存储格式中，静态格式是最简单和最安全的（最少受到损坏）。 它也是最快的磁盘格式，因为可以轻松地在磁盘上找到数据文件中的行：要根据索引中的行号查找行，请将行号乘以行长 以计算行位置。 此外，当扫描表时，在每次磁盘读取操作时很容易读取恒定数量的行。</dd>

<dd>3 固定长度行格式仅适用于没有BLOB或TEXT列的表。 使用带有显式ROW_FORMAT子句的这些列创建表不会引发错误或警告; 格式规范将被忽略。 <br>
4 CHAR和VARCHAR列以空格填充到指定的列宽，尽管列类型不更改。 BINARY和VARBINARY列用0x00字节填充到列宽。 <br>
5 NULL列在行中需要额外的空间来记录它们的值是否为NULL。 每个NULL列需要一个额外的位，向上舍入到最接近的字节。 <br>
6 很快。 <br>
7 容易缓存。 <br>
8 易于在崩溃后重建，因为行位于固定位置。 <br>
9 重组是不必要的，除非您删除了大量的行，并希望将可用磁盘空间返回到操作系统。 为此，请使用OPTIMIZE TABLE或myisamchk -r。 <br>
10 通常需要比动态格式表更多的磁盘空间。</dd>

<dt>动态表特性</dt>
<dd>1 如果MyISAM表包含任何可变长度列（VARCHAR，VARBINARY，BLOB或TEXT），或者表是使用ROW_FORMAT = DYNAMIC表选项创建的，则使用动态存储格式。</dd>

<dd>2 动态格式比静态格式复杂一点，因为每一行都有一个标题，表示它有多长。 当由于更新而变长时，行可能变得碎片化（以不连续的片段存储）。</dd>

<dd>3 可以使用OPTIMIZE TABLE或myisamchk -r对表进行碎片整理。 如果具有在包含一些可变长度列的表中访问或更改的固定长度的列，最好将可变长度列移动到其他表，以避免碎片。</dd>

<dd>4 所有字符串列都是动态的，除非长度小于4。 <br>
5 每行前面都有一个位图，指示哪些列包含空字符串（对于字符串列）或零（对于数字列）。 这不包括包含NULL值的列。 如果字符串列在删除尾部空格后的长度为零，或者数值列的值为零，则会在位图中标记，而不会保存到磁盘。 非空字符串保存为长度字节加上字符串内容。 <br>
6 NULL列在行中需要额外的空间来记录它们的值是否为NULL。 每个NULL列需要一个额外的位，向上舍入到最接近的字节。 <br>
7 通常比固定长度表需要更少的磁盘空间。 <br>
8 每行仅使用所需的空间。 但是，如果行变大，则会将其拆分为所需的数量，从而导致行碎片。 例如，如果使用扩展行长度的信息更新行，则行会变成碎片。 在这种情况下，您可能需要不时运行OPTIMIZE TABLE或myisamchk -r以提高性能。 使用myisamchk -ei获取表统计信息。 <br>
9 比静态格式表更难以在崩溃后重建，因为行可能被分段成许多块，链接（片段）可能会丢失。</dd>
</dl>



<h2 id="myisam表问题">MyISAM表问题</h2>

<dl>
<dt>MySQL用于存储数据的文件格式已经过广泛测试，但总是存在可能导致数据库表损坏的情况。 以下讨论描述了这种情况如何发生以及如何处理它。</dt>
<dt>出现损坏表的原因：</dt>
<dd>1 mysqld进程在写入的中间被杀死。 <br>
2 生意外的计算机关机（例如，计算机关闭）。 <br>
3 硬件故障。 <br>
4 您正在使用外部程序（例如myisamchk）来修改服务器正在同时修改的表。 <br>
5 MySQL或MyISAM代码中的一个bug错误。</dd>

<dt>损坏表的典型症状如下：</dt>
<dd>1 从表中选择数据时出现以下错误</dd>
</dl>



<pre class="prettyprint"><code class=" hljs livecodeserver">Incorrect key <span class="hljs-built_in">file</span> <span class="hljs-keyword">for</span> table: <span class="hljs-string">'...'</span>. Try <span class="hljs-built_in">to</span> repair <span class="hljs-keyword">it</span></code></pre>

<dl>
<dt>&gt;</dt>
<dd>2  表没有正确关闭的问题 <br>
每个MyISAM索引文件（.MYI文件）在标题中都有一个计数器，可用于检查表是否已正确关闭。 如果从CHECK TABLE或myisamchk获得以下警告，则表示此计数器已不同步：</dd>
</dl>



<pre class="prettyprint"><code class=" hljs vbnet">clients are <span class="hljs-keyword">using</span> <span class="hljs-keyword">or</span> haven<span class="hljs-comment">'t closed the table properly</span></code></pre>

<blockquote>
  <p>此警告不一定意味着表已损坏，但应至少检查表。 <br>
  只有在这些条件下，计数器才会变得不正确： <br>
  复制MyISAM表，而不首先发出LOCK TABLES和FLUSH TABLES。 <br>
  MySQL在更新和最后关闭之间崩溃。 <br>
  表被myisamchk –recover或myisamchk –update-state修改，同时它被mysqld使用。 <br>
  多个mysqld服务器正在使用该表，并且一个服务器在表由另一个服务器使用时对其执行REPAIR TABLE或CHECK </p>
</blockquote>



<h2 id="mysql的配置">mysql的配置</h2>

<dl>
<dt>MySQL是如何使用内存的</dt>
<dd>MySQL性能模式是一种用于以低级别监视MySQL服务器执行的功能。 从MySQL 5.7开始，性能模式会逐步动态分配内存，将其内存使用扩展到实际的服务器负载，而不是在服务器启动期间分配所需的内存。 一旦分配内存，在服务器重新启动之前不会释放内存。</dd>

<dd>
<p>对于打开的每个MyISAM表，索引文件将打开一次; 对于每个并发运行的线程，数据文件打开一次。 对于每个并发线程，分配表结构，每个列的列结构和大小为3 * N的缓冲区（其中N是最大行长度，不计算BLOB列）。 BLOB列需要五到八个字节加上BLOB数据的长度。 MyISAM存储引擎维护一个额外的行缓冲区供内部使用。</p>
</dd>

<dd>
<p>所有线程共享相同的基本内存。</p>
</dd>

<dd>当不再需要线程时，分配给它的内存被释放并返回到系统，除非线程返回到线程高速缓存中。 在这种情况下，内存保持分配。</dd>

<dd>myisam_use_mmap系统变量可以设置为1，以便为所有MyISAM表启用内存映射。</dd>

<dd>
<p>所有连接查询都在单次传递中执行，并且大多数连接可以在不使用临时表的情况下完成。 大多数临时表是基于内存的哈希表。 具有大行长度（计算为所有列长度的总和）或包含BLOB列的临时表存储在磁盘上。</p>
</dd>

<dd>
<p>几乎所有的解析和计算都是在线程本地和可重用的内存池中完成的。 小项目不需要内存开销，因此避免了正常的缓慢内存分配和释放。 内存只分配给意外的大字符串。</p>
</dd>

<dd>
<p>对于具有BLOB列的每个表，缓冲器被动态地放大以读取较大的BLOB值。 如果扫描表，将分配与最大BLOB值一样大的缓冲区。</p>
</dd>

<dd>
<p>MySQL还需要为表定义缓存提供内存。 table_definition_cache系统变量定义可以存储在表定义高速缓存中的表定义（来自.frm文件）的数量。 如果使用大量表，则可以创建大型表定义高速缓存以加快表的打开速度。 表定义缓存占用较少的空间，不使用文件描述符，与表缓存不同。</p>
</dd>
</dl>

<p>FLUSH TABLES语句或mysqladmin flush-tables命令会关闭所有未同时使用的表，并在当前正在执行的线程完成时将所有正在使用的表标记为关闭。 这有效地释放了大多数使用中的内存。 FLUSH TABLES不会返回，直到所有表都已关闭。</p>

<dl>
<dt>用于管理客户端连接的每个线程都使用一些线程特定的空间。 以下列表指示这些和哪些变量控制它们的大小：</dt>
<dd>key_buffer_size

<blockquote>
  所有线程共享MyISAM密钥缓冲区; 其大小由key_buffer_size变量确定。 服务器使用的其他缓冲区根据需要分配。
</blockquote></dd>

<dd>thread_stack

<blockquote>
  堆栈
</blockquote></dd>

<dd>
<p>net_buffer_length</p>

<blockquote>
  <p>连接缓冲区/结果缓冲区(连接缓冲区和结果缓冲区每个以等于net_buffer_length字节的大小开始，但是根据需要被动态地放大到max_allowed_packet字节。 每个SQL语句后，结果缓冲区缩减为net_buffer_length个字节。 当一个语句运行时，还分配当前语句字符串的副本。)在MySQL 5.7.4之前，如果性能模式使用语句检测编译，则每个会话为1024字节。 在5.7.4和5.7.5中，每个会话1024字节。 在5.7.6和更高版本中，每个会话的max_digest_length字节。 <br>
  所有线程共享相同的基本内存。</p>
</blockquote>
</dd>

<dd>
<p>read_buffer_size</p>

<blockquote>
  <p>执行表的顺序扫描的每个请求都会分配一个读缓冲区</p>
</blockquote>
</dd>

<dd>
<p>read_rnd_buffer_size</p>

<blockquote>
  <p>当以任意序列（例如，排序后）读取行时，可以分配随机读缓冲器（ read_rnd_buffer_size）以避免盘寻道。</p>
</blockquote>
</dd>

<dd>
<p>internal_tmp_disk_storage_engine</p>

<blockquote>
  <p>如果内部内存临时表变得太大，MySQL会通过将表从内存中更改为磁盘格式来自动处理，由internal_tmp_disk_storage_engine定义的存储引擎处理。 可以增加允许的临时表大小。大多数执行排序的请求根据结果集大小分配排序缓冲区和0-2个临时文件。</p>
</blockquote>
</dd>

<dd>
<p>table_open_cache</p>

<blockquote>
  <p>MySQL需要内存和表缓存的描述符。 所有使用中的表的处理程序结构都保存在表缓存中，并作为“先进先出”（FIFO）管理。 初始表缓存大小由table_open_cache系统变量定义</p>
</blockquote>
</dd>

<dd>
<p>table_definition_cache</p>

<blockquote>
  <p>MySQL还需要为表定义缓存提供内存。 table_definition_cache系统变量定义可以存储在表定义高速缓存中的表定义（来自.frm文件）的数量。 如果使用大量表，则可以创建大型表定义高速缓存以加快表的打开速度。 表定义缓存占用较少的空间，不使用文件描述符，与表缓存不同。</p>
</blockquote>
</dd>
</dl>                                    </div>
                <link href="https://csdnimg.cn/release/phoenix/mdeditor/markdown_views-e44c3c0e64.css" rel="stylesheet">
                    </div>
    </article>
</div>

            <div class="hide-article-box hide-article-pos text-center">
            <a class="btn-readmore" data-report-view='{"mod":"popu_376","dest":"https://blog.csdn.net/redbloodbody/article/details/58185240","strategy":"readmore"}' data-report-click='{"mod":"popu_376","dest":"https://blog.csdn.net/redbloodbody/article/details/58185240","strategy":"readmore"}'>
                展开阅读全文
                <svg class="icon chevrondown" aria-hidden="true">
                    <use xlink:href="#csdnc-chevrondown"></use>
                </svg>
            </a>
        </div>
    
<script>
    $(".MathJax").remove();
    if ($('div.markdown_views pre.prettyprint code.hljs').length > 0) {
        $('div.markdown_views')[0].className = 'markdown_views';
    }
    var persentSet = 1;
</script>

<script src="https://csdnimg.cn/release/phoenix/vendor/linkCatcher/linkCatcher-3a08af3a5f.js"></script>        <div id="dmp_ad_58"><div id="kp_box_58" data-pid="58" data-track-view='{"mod":"kp_popu_58-386","con":",,"}' data-track-click='{"mod":"kp_popu_58-386","con":",,"}' data-report-view='{"mod":"kp_popu_58-386","keyword":""}' data-report-click='{"mod":"kp_popu_58-386","keyword":""}'><div style="width:100%;background:#fff;">
<script type="text/javascript" src="//rabc1.iteye.com/production/resource/web/6xwm4l.js?lg=ydmpioh"></script>
</div></div></div>        <a id="commentBox"></a>
<div class="comment-box">
	
	<div class="comment-edit-box d-flex">
		<a id="commentsedit"></a>
		<div class="user-img">
			<a href="javascript:void(0);" target="_blank">
				<img class="show_loginbox" src="//g.csdnimg.cn/static/user-img/anonymous-User-img.png">
			</a>
		</div>
		<form id="commentform">
			<input type="hidden" id="comment_replyId">
			<textarea class="comment-content" name="comment_content" id="comment_content" placeholder="想对作者说点什么"></textarea>
			<div class="opt-box"> <!-- d-flex -->
				<div id="ubbtools" class="add_code">
					<a href="#insertcode" code="code" target="_self"><i class="icon iconfont icon-daima"></i></a>
				</div>
				<input type="hidden" id="comment_replyId" name="comment_replyId">
				<input type="hidden" id="article_id" name="article_id" value="58185240">
				<input type="hidden" id="comment_userId" name="comment_userId" value="">
				<input type="hidden" id="commentId" name="commentId" value="">
				<div style="display: none;" class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_384","dest":""}'><a href="#" target="_blank" class="comment_area_btn">发表评论</a></div>
				<div class="dropdown" id="myDrap">
					<a class="dropdown-face d-flex align-items-center" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
					<div class="txt-selected text-truncate">添加代码片</div>
					<svg class="icon d-block" aria-hidden="true">
						<use xlink:href="#csdnc-triangledown"></use>
					</svg>
					</a>
					<ul class="dropdown-menu" id="commentCode" aria-labelledby="drop4">
						<li><a data-code="html">HTML/XML</a></li>
						<li><a data-code="objc">objective-c</a></li>
						<li><a data-code="ruby">Ruby</a></li>
						<li><a data-code="php">PHP</a></li>
						<li><a data-code="csharp">C</a></li>
						<li><a data-code="cpp">C++</a></li>
						<li><a data-code="javascript">JavaScript</a></li>
						<li><a data-code="python">Python</a></li>
						<li><a data-code="java">Java</a></li>
						<li><a data-code="css">CSS</a></li>
						<li><a data-code="sql">SQL</a></li>
						<li><a data-code="plain">其它</a></li>
					</ul>
				</div>  
				<div class="right-box">
					<span id="tip_comment" class="tip">还能输入<em>1000</em>个字符</span>
					<input type="button" class="btn btn-sm btn-cancel d-none" value="取消回复">
					<input type="submit" class="btn btn-sm btn-red btn-comment" value="发表评论">
				</div>
			</div>
		</form>
	</div>

		<div class="comment-list-container">
		<a id="comments"></a>
		<div class="comment-list-box">
		</div>
		<div id="commentPage" class="pagination-box d-none"></div>
		<div class="opt-box text-center">
			<div class="btn btn-sm btn-link-blue" id="btnMoreComment"></div>
		</div>
	</div>
</div>
        <div class="recommend-box">
                            <div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/lijieshare/article/details/84920369","strategy":"BlogCommendFromBaidu","index":"0"}'>
	<div class="content">
		<a href="https://blog.csdn.net/lijieshare/article/details/84920369" target="_blank" title="【MySQL中MyISAM与InnoDB区别】">
		<h4 class="text-truncate oneline">
				【<em>MySQL</em>中<em>MyISAM</em>与InnoDB区别】		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-10</span>
				<span class="read-num hover-hide">
					阅读数 
					22</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/lijieshare/article/details/84920369" target="_blank" title="【MySQL中MyISAM与InnoDB区别】">
				<span class="desc oneline">1、存储结构 每个MyISAM在磁盘上存储成三个文件。第一个文件的名字以表的名字开始，扩展名指出文件类型。 .frm文件存储表定义。 数据文件的扩展名为.MYD(MYData)。 索引文件的扩展名是....</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/lijieshare">来自：	<span class="blog_title"> 计算机软件技术分享--赠人玫瑰,手遗余香（QQ群516569942）</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/z702143700/article/details/46049101","strategy":"BlogCommendFromBaidu","index":"1"}'>
	<div class="content">
		<a href="https://blog.csdn.net/z702143700/article/details/46049101" target="_blank" title="MyISAM和InnoDB索引实现对比">
		<h4 class="text-truncate oneline">
				<em>MyISAM</em>和InnoDB索引实现对比		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-27</span>
				<span class="read-num hover-hide">
					阅读数 
					5881</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/z702143700/article/details/46049101" target="_blank" title="MyISAM和InnoDB索引实现对比">
				<span class="desc oneline">在数据库开发中，了解不同存储引擎的索引实现方式对于正确使用和优化索引都非常有帮助。例如，知道了InnoDB的索引实现后，就很容易明白为什么不建议使用过长的字段作为主键，因为所有辅助索引都引用主索引，过...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/z702143700">来自：	<span class="blog_title"> 奔跑的小河</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/ma15732625261/article/details/81450980","strategy":"BlogCommendFromBaidu","index":"2"}'>
	<div class="content">
		<a href="https://blog.csdn.net/ma15732625261/article/details/81450980" target="_blank" title="【MySQL】我必须得告诉大家的MySQL优化原理3（中）配置+MyISAM配置">
		<h4 class="text-truncate oneline">
				【<em>MySQL</em>】我必须得告诉大家的<em>MySQL</em>优化原理3（中）配置+<em>MyISAM</em>配置		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-06</span>
				<span class="read-num hover-hide">
					阅读数 
					729</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/ma15732625261/article/details/81450980" target="_blank" title="【MySQL】我必须得告诉大家的MySQL优化原理3（中）配置+MyISAM配置">
				<span class="desc oneline">给你一个基本的MySQL配置前面已经说到，MySQL可配置性太强，看起来需要花很多时间在配置上，但其实大多数配置的默认值已经是最佳的，最好不要轻易改动太多的配置，你甚至不需要知道某些配置的存在。这里有...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/ma15732625261">来自：	<span class="blog_title"> 星小丫头辰</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_36071795/article/details/83956125","strategy":"BlogCommendFromBaidu","index":"3"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_36071795/article/details/83956125" target="_blank" title="MySql何时用MyISAM何时用InnoDB">
		<h4 class="text-truncate oneline">
				<em>MySql</em>何时用<em>MyISAM</em>何时用InnoDB		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-11</span>
				<span class="read-num hover-hide">
					阅读数 
					813</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_36071795/article/details/83956125" target="_blank" title="MySql何时用MyISAM何时用InnoDB">
				<span class="desc oneline"> MySql何时用MyISAM何时用InnoDBMyISAM和InnoDB是MySQL提供的两种搜索引擎MyISAM和InnoDB的区别①InnoDB支持事务与外键和行级锁,MyISAM不支持(最主要...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_36071795">来自：	<span class="blog_title"> 不羁朔风的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_59" data-pid="59" data-track-view='{"mod":"kp_popu_59-78","con":",,"}' data-track-click='{"mod":"kp_popu_59-78","con":",,"}' data-report-view='{"mod":"kp_popu_59-78","keyword":""}' data-report-click='{"mod":"kp_popu_59-78","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3491668",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/frycn/article/details/70158313","strategy":"BlogCommendFromBaidu","index":"4"}'>
	<div class="content">
		<a href="https://blog.csdn.net/frycn/article/details/70158313" target="_blank" title="MySQL中MyISAM与InnoDB区别及选择">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>中<em>MyISAM</em>与InnoDB区别及选择		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-13</span>
				<span class="read-num hover-hide">
					阅读数 
					6万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/frycn/article/details/70158313" target="_blank" title="MySQL中MyISAM与InnoDB区别及选择">
				<span class="desc oneline">InnoDB：支持事务处理等不加锁读取支持外键支持行锁不支持FULLTEXT类型的索引不保存表的具体行数，扫描表来计算有多少行DELETE表时，是一行一行的删除InnoDB把数据和索引存放在表空间里面...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/frycn">来自：	<span class="blog_title"> 老刘的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_16525279/article/details/82775764","strategy":"BlogCommendFromBaidu","index":"5"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_16525279/article/details/82775764" target="_blank" title="MySQL锁概述&amp;MyISAM 表锁">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>锁概述&amp;<em>MyISAM</em> 表锁		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-19</span>
				<span class="read-num hover-hide">
					阅读数 
					196</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_16525279/article/details/82775764" target="_blank" title="MySQL锁概述&amp;MyISAM 表锁">
				<span class="desc oneline">概述相对其他数据库而言，MySQL的锁机制比较简单，其最显著的特点是不同的存储引擎支持不同的锁机制。比如，MyISAM和MEMORY存储引擎采用的是表级锁（table-levellocking）；BD...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_16525279">来自：	<span class="blog_title"> z止于至善的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_38038480/article/details/81592828","strategy":"BlogCommendFromBaidu","index":"6"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_38038480/article/details/81592828" target="_blank" title="面试题：MySQL的innodb和myisam">
		<h4 class="text-truncate oneline">
				面试题：<em>MySQL</em>的innodb和<em>myisam</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-13</span>
				<span class="read-num hover-hide">
					阅读数 
					2174</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_38038480/article/details/81592828" target="_blank" title="面试题：MySQL的innodb和myisam">
				<span class="desc oneline">一Innodb1.简介索引是一种排好序的用于快速查找的数据结构。根据官网手册InnoDB支持B-tree索引、Clusteredindexes（聚簇索引）、Full-textsearchindexes...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_38038480">来自：	<span class="blog_title"> PetrichorKe</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/xifeijian/article/details/20316775","strategy":"BlogCommendFromBaidu","index":"7"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xifeijian/article/details/20316775" target="_blank" title="MySQL存储引擎－－MyISAM与InnoDB区别">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>存储引擎－－<em>MyISAM</em>与InnoDB区别		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-03</span>
				<span class="read-num hover-hide">
					阅读数 
					22万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xifeijian/article/details/20316775" target="_blank" title="MySQL存储引擎－－MyISAM与InnoDB区别">
				<span class="desc oneline">MyISAM和InnoDB讲解　　InnoDB和MyISAM是许多人在使用MySQL时最常用的两个表类型，这两个表类型各有优劣，视具体应用而定。基本的差别为：MyISAM类型不支持事务处理等高级处理，...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xifeijian">来自：	<span class="blog_title"> 上善若水，水善利万物而不争。</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_36586120/article/details/88377800","strategy":"BlogCommendFromBaidu","index":"8"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_36586120/article/details/88377800" target="_blank" title="MySQL——MyISAM 表锁">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>——<em>MyISAM</em> 表锁		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-10</span>
				<span class="read-num hover-hide">
					阅读数 
					18</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_36586120/article/details/88377800" target="_blank" title="MySQL——MyISAM 表锁">
				<span class="desc oneline">MyISAM表锁锁的概念：MySQL的表级锁有两种模式：给表显示加锁：MyISAM表不会出现死锁（DeadlockFree）的原因MyISAM的锁调度另一类表级锁MDL锁（metadatalock)总...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_36586120">来自：	<span class="blog_title"> Stefan</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_60" data-pid="60" data-track-view='{"mod":"kp_popu_60-43","con":",,"}' data-track-click='{"mod":"kp_popu_60-43","con":",,"}' data-report-view='{"mod":"kp_popu_60-43","keyword":""}' data-report-click='{"mod":"kp_popu_60-43","keyword":""}'><div id="three_ad8" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad8",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/UFO___/article/details/80794902","strategy":"BlogCommendFromBaidu","index":"9"}'>
	<div class="content">
		<a href="https://blog.csdn.net/UFO___/article/details/80794902" target="_blank" title="MySQL系列-MyISAM表锁详解">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>系列-<em>MyISAM</em>表锁详解		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-24</span>
				<span class="read-num hover-hide">
					阅读数 
					723</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/UFO___/article/details/80794902" target="_blank" title="MySQL系列-MyISAM表锁详解">
				<span class="desc oneline">1.S锁和X锁S锁（共享锁）又称读锁，若事务T对数据对象A加上S锁，则事务T可以读A但不能修改A，其他事务只能再对A加S锁，而不能加X锁，直到T释放A上的S锁。这保证了其他事务可以读A，但在T释放A上...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/UFO___">来自：	<span class="blog_title"> UFO___的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34186950/article/details/92922356","strategy":"BlogCommendFromBaidu","index":"10"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34186950/article/details/92922356" target="_blank" title="给root用户添加远程连接权限">
		<h4 class="text-truncate oneline">
				给root用户添加远程连接权限		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-27</span>
				<span class="read-num hover-hide">
					阅读数 
					2</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34186950/article/details/92922356" target="_blank" title="给root用户添加远程连接权限">
				<span class="desc oneline">环境说明：linuxas5mysql数据库主机IP：192.168.1.1root/123456远程主机windowsxpIP：192.168.1.2一.建立数据库[root@mail/root]#m...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34186950">来自：	<span class="blog_title"> weixin_34186950的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
			<div class="recommend-item-box blog-expert-recommend-box">
			<div class="d-flex">
				<div class="blog-expert-recommend">
					<div class="blog-expert">
						<div class="blog-expert-flexbox"></div>
					</div>
				</div>
			</div>
		</div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/a1282379904/article/details/84835035","strategy":"BlogCommendFromBaidu","index":"11"}'>
	<div class="content">
		<a href="https://blog.csdn.net/a1282379904/article/details/84835035" target="_blank" title="MySQL MyISAM与表锁">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> <em>MyISAM</em>与表锁		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-11</span>
				<span class="read-num hover-hide">
					阅读数 
					39</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/a1282379904/article/details/84835035" target="_blank" title="MySQL MyISAM与表锁">
				<span class="desc oneline">MySQLMyISAM与表锁 在数据库中，除了CPU、内存、IO等的争用外，数据也是一种供许多用户共享的资源，如何保证数据并发的一致性、有效性是所有数据库必须解决的问题，锁冲突也是影响数据库并发性能的...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/a1282379904">来自：	<span class="blog_title"> 莫名的拉风的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/LJFPHP/article/details/80029968","strategy":"BlogCommendFromBaidu","index":"12"}'>
	<div class="content">
		<a href="https://blog.csdn.net/LJFPHP/article/details/80029968" target="_blank" title="MySQL中MyISAM和InnoDB的索引方式以及区别与选择">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>中<em>MyISAM</em>和InnoDB的索引方式以及区别与选择		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-21</span>
				<span class="read-num hover-hide">
					阅读数 
					7070</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/LJFPHP/article/details/80029968" target="_blank" title="MySQL中MyISAM和InnoDB的索引方式以及区别与选择">
				<span class="desc oneline">一、索引1、什么是索引&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;索引是一种帮助mysql高效的获取数据的数据结构，这些数据...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/LJFPHP">来自：	<span class="blog_title"> 铁柱的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34198797/article/details/91925906","strategy":"BlogCommendFromBaidu","index":"13"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34198797/article/details/91925906" target="_blank" title="MySQL数据库MyISAM转换InnoDB方法">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>数据库<em>MyISAM</em>转换InnoDB方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-22</span>
				<span class="read-num hover-hide">
					阅读数 
					7</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34198797/article/details/91925906" target="_blank" title="MySQL数据库MyISAM转换InnoDB方法">
				<span class="desc oneline">2019独角兽企业重金招聘Python工程师标准&amp;gt;&amp;gt;&amp;gt;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34198797">来自：	<span class="blog_title"> weixin_34198797的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_61" data-pid="61" data-track-view='{"mod":"kp_popu_61-557","con":",,"}' data-track-click='{"mod":"kp_popu_61-557","con":",,"}' data-report-view='{"mod":"kp_popu_61-557","keyword":""}' data-report-click='{"mod":"kp_popu_61-557","keyword":""}'><div id="three_ad13" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad13",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/lbr2008/article/details/79257793","strategy":"BlogCommendFromBaidu","index":"14"}'>
	<div class="content">
		<a href="https://blog.csdn.net/lbr2008/article/details/79257793" target="_blank" title="MySQL高级开发 -- 表锁（MyISAM）">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>高级开发 -- 表锁（<em>MyISAM</em>）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-05</span>
				<span class="read-num hover-hide">
					阅读数 
					503</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/lbr2008/article/details/79257793" target="_blank" title="MySQL高级开发 -- 表锁（MyISAM）">
				<span class="desc oneline">MySQL高级开发–表锁（MyISAM）标签（空格分隔）：MySQLMySQL高级开发表锁MyISAM什么是锁锁的分类及对比读锁写锁总结锁分析什么是锁锁是计算机协调多个进程或者线程并发访问某一个资源的...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/lbr2008">来自：	<span class="blog_title"> lbr2008的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/okiwilldoit/article/details/51679807","strategy":"BlogCommendFromBaidu","index":"15"}'>
	<div class="content">
		<a href="https://blog.csdn.net/okiwilldoit/article/details/51679807" target="_blank" title="MySQL存储引擎中的MyISAM和InnoDB区别">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>存储引擎中的<em>MyISAM</em>和InnoDB区别		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-15</span>
				<span class="read-num hover-hide">
					阅读数 
					162</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/okiwilldoit/article/details/51679807" target="_blank" title="MySQL存储引擎中的MyISAM和InnoDB区别">
				<span class="desc oneline">MyISAM是MySQL的默认数据库引擎（5.5版之前），由早期的ISAM（IndexedSequentialAccessMethod：有索引的顺序访问方法）所改良。虽然性能极佳，但却有一个缺点：不支...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/okiwilldoit">来自：	<span class="blog_title"> 罗布泊coding</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/designer01/article/details/83018786","strategy":"BlogCommendFromBaidu","index":"16"}'>
	<div class="content">
		<a href="https://blog.csdn.net/designer01/article/details/83018786" target="_blank" title="阅读笔记-mysql myisam和innodb的五个差异">
		<h4 class="text-truncate oneline">
				阅读笔记-<em>mysql</em> <em>myisam</em>和innodb的五个差异		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-11</span>
				<span class="read-num hover-hide">
					阅读数 
					67</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/designer01/article/details/83018786" target="_blank" title="阅读笔记-mysql myisam和innodb的五个差异">
				<span class="desc oneline">count(*)对于myisam引擎，会直接存储总行数，所以比较快；但是如果一旦添加了查询条件则统计方式和innodb相同（一行一行的扫描）所以不管用什么引擎都要建立好索引全文索引MyIsam支持，i...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/designer01">来自：	<span class="blog_title"> designer01的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/luoxq111/article/details/54572390","strategy":"BlogCommendFromBaidu","index":"17"}'>
	<div class="content">
		<a href="https://blog.csdn.net/luoxq111/article/details/54572390" target="_blank" title="mysql更改表引擎INNODB为MyISAM的方法总结">
		<h4 class="text-truncate oneline">
				<em>mysql</em>更改表引擎INNODB为<em>MyISAM</em>的方法总结		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-16</span>
				<span class="read-num hover-hide">
					阅读数 
					7707</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/luoxq111/article/details/54572390" target="_blank" title="mysql更改表引擎INNODB为MyISAM的方法总结">
				<span class="desc oneline">mysql数据库分类为INNODB为MyISAM两种表存储引擎了，两种各有优化在不同类型网站可能选择不同，下面小编为各位介绍mysql更改表引擎INNODB为MyISAM技巧。常见的mysql表引擎有...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/luoxq111">来自：	<span class="blog_title"> 专注企业信息化</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/391936122","strategy":"BlogCommendFromBaidu","index":"18"}'>
	<a href="https://bbs.csdn.net/topics/391936122" target="_blank">
		<h4 class="text-truncate oneline">
				<em>mysql</em>的innodb引擎比<em>myisam</em>引擎占空间吗		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">04-17</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">如题，是不是mysql的innodb引擎比myisam引擎占空间</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_62" data-pid="62" data-track-view='{"mod":"kp_popu_62-1062","con":",,"}' data-track-click='{"mod":"kp_popu_62-1062","con":",,"}' data-report-view='{"mod":"kp_popu_62-1062","keyword":""}' data-report-click='{"mod":"kp_popu_62-1062","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/237?positionId=62&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/light_language/article/details/72614806","strategy":"BlogCommendFromBaidu","index":"19"}'>
	<div class="content">
		<a href="https://blog.csdn.net/light_language/article/details/72614806" target="_blank" title="MySQL锁——MyISAM锁">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>锁——<em>MyISAM</em>锁		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-21</span>
				<span class="read-num hover-hide">
					阅读数 
					319</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/light_language/article/details/72614806" target="_blank" title="MySQL锁——MyISAM锁">
				<span class="desc oneline">MySQL锁机制：不同的存储引擎支持不同的锁机制。表级锁：开销小、加锁快;不会出现死锁;锁粒度大，发生锁冲突的概率高，并发度低。页面锁：性能和并发性都介于表级锁和行级锁之间。行级锁：开销大、加锁慢;会...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/light_language">来自：	<span class="blog_title"> light_language的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/iteye_4388/article/details/81820992","strategy":"BlogCommendFromBaidu","index":"20"}'>
	<div class="content">
		<a href="https://blog.csdn.net/iteye_4388/article/details/81820992" target="_blank" title="InnoDB还是MyISAM 再谈MySQL存储引擎的选择">
		<h4 class="text-truncate oneline">
				InnoDB还是<em>MyISAM</em> 再谈<em>MySQL</em>存储引擎的选择		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-27</span>
				<span class="read-num hover-hide">
					阅读数 
					15</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/iteye_4388/article/details/81820992" target="_blank" title="InnoDB还是MyISAM 再谈MySQL存储引擎的选择">
				<span class="desc oneline">两种类型最主要的差别就是Innodb支持事务处理与外键和行级锁.而MyISAM不支持.所以MyISAM往往就容易被人认为只适合在小项目中使用。我作为使用MySQL的用户角度出发，Innodb和MyIS...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/iteye_4388">来自：	<span class="blog_title"> ruilin521314</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/renwudao24/article/details/52136955","strategy":"BlogCommendFromBaidu","index":"21"}'>
	<div class="content">
		<a href="https://blog.csdn.net/renwudao24/article/details/52136955" target="_blank" title="MySQL创建数据表时设定引擎MyISAM/InnoDB">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>创建数据表时设定引擎<em>MyISAM</em>/InnoDB		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-06</span>
				<span class="read-num hover-hide">
					阅读数 
					2万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/renwudao24/article/details/52136955" target="_blank" title="MySQL创建数据表时设定引擎MyISAM/InnoDB">
				<span class="desc oneline">MySQL创建数据表时设定引擎MyISAM/InnoDB</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/renwudao24">来自：	<span class="blog_title"> renwudao24的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u010286334/article/details/48174853","strategy":"BlogCommendFromBaidu","index":"22"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u010286334/article/details/48174853" target="_blank" title="mysql配置--MyISAM相关参数">
		<h4 class="text-truncate oneline">
				<em>mysql</em>配置--<em>MyISAM</em>相关参数		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-02</span>
				<span class="read-num hover-hide">
					阅读数 
					352</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u010286334/article/details/48174853" target="_blank" title="mysql配置--MyISAM相关参数">
				<span class="desc oneline">1、myisam_max_sort_file_size=100G#mysql重建索引时允许使用的临时文件最大大小2、myisam_sort_buffer_size=68M3、key_buffer_si...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u010286334">来自：	<span class="blog_title"> 我是谁</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34355559/article/details/85746300","strategy":"BlogCommendFromBaidu","index":"23"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34355559/article/details/85746300" target="_blank" title="mysql中innodb和myisam的区别">
		<h4 class="text-truncate oneline">
				<em>mysql</em>中innodb和<em>myisam</em>的区别		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-13</span>
				<span class="read-num hover-hide">
					阅读数 
					3</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34355559/article/details/85746300" target="_blank" title="mysql中innodb和myisam的区别">
				<span class="desc oneline">InnoDB和MyISAM是很多人在使用MySQL时最常用的两个表类型，这两个表类型各有优劣，5.7之后就不一样了1、事务和外键InnoDB具有事务，支持4个事务隔离级别，回滚，崩溃修复能力和多版本并...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34355559">来自：	<span class="blog_title"> weixin_34355559的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_63" data-pid="63" data-track-view='{"mod":"kp_popu_63-1059","con":",,"}' data-track-click='{"mod":"kp_popu_63-1059","con":",,"}' data-report-view='{"mod":"kp_popu_63-1059","keyword":""}' data-report-click='{"mod":"kp_popu_63-1059","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/234?positionId=63&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34199405/article/details/91553071","strategy":"BlogCommendFromBaidu","index":"24"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34199405/article/details/91553071" target="_blank" title="MySql【MyISAM InnoDB 区别】">
		<h4 class="text-truncate oneline">
				<em>MySql</em>【<em>MyISAM</em> InnoDB 区别】		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-20</span>
				<span class="read-num hover-hide">
					阅读数 
					7</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34199405/article/details/91553071" target="_blank" title="MySql【MyISAM InnoDB 区别】">
				<span class="desc oneline">InnoDB和MyISAM是许多人在使用MySQL时最常用的两个表类型，这两个表类型各有优劣，视具体应用而定。基本的差别为：MyISAM类型不支持事务处理等高级处理，而InnoDB类型支持。MyISA...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34199405">来自：	<span class="blog_title"> weixin_34199405的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/nzing/article/details/7019048","strategy":"BlogCommendFromBaidu","index":"25"}'>
	<div class="content">
		<a href="https://blog.csdn.net/nzing/article/details/7019048" target="_blank" title="MySQL数据库MyISAM和InnoDB存储引擎的比较">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>数据库<em>MyISAM</em>和InnoDB存储引擎的比较		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-28</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/nzing/article/details/7019048" target="_blank" title="MySQL数据库MyISAM和InnoDB存储引擎的比较">
				<span class="desc oneline">MySQL数据库MyISAM和InnoDB存储引擎的比较MySQL有多种存储引擎，MyISAM和InnoDB是其中常用的两种。这里介绍关于这两种引擎的一些基本概念（非深入介绍）。MyISAM是MySQ...</span>
			</a>
			<span class="blog_title_box oneline no-title">
									<span class="type-show type-show-blog type-show-after">博文</span>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/fbd2011/article/details/7057109","strategy":"BlogCommendFromBaidu","index":"26"}'>
	<div class="content">
		<a href="https://blog.csdn.net/fbd2011/article/details/7057109" target="_blank" title="MySQL数据库存储引擎MyISAM和InnoDB的详解对比">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>数据库存储引擎<em>MyISAM</em>和InnoDB的详解对比		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-09</span>
				<span class="read-num hover-hide">
					阅读数 
					534</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/fbd2011/article/details/7057109" target="_blank" title="MySQL数据库存储引擎MyISAM和InnoDB的详解对比">
				<span class="desc oneline">之前Eugene兄已经写过两篇关于myisam转innodb引擎的文章，我今天把myisam和innodb引擎的差别做了一个整理，目的是让大家更深的理解两个引擎的差别之处，让大家在项目初期选择数据库引...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/fbd2011">来自：	<span class="blog_title"> 2x 青年，欢乐多。</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/chuan442616909/article/details/62418929","strategy":"BlogCommendFromBaidu","index":"27"}'>
	<div class="content">
		<a href="https://blog.csdn.net/chuan442616909/article/details/62418929" target="_blank" title="mysql-innodb与myisam分析">
		<h4 class="text-truncate oneline">
				<em>mysql</em>-innodb与<em>myisam</em>分析		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-16</span>
				<span class="read-num hover-hide">
					阅读数 
					317</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/chuan442616909/article/details/62418929" target="_blank" title="mysql-innodb与myisam分析">
				<span class="desc oneline">innodbinnodb在主索引文件上直接存放改行数据，次索引指向对主键的引用，同时也叫作聚簇索引1.主键索引既存储索引值，又在叶子中存储行的数据2.如果没有主键，则会自动产生uniquekey做主键...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/chuan442616909">来自：	<span class="blog_title"> 豆豆不在了</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/huanglong8/article/details/53837822","strategy":"BlogCommendFromBaidu","index":"28"}'>
	<div class="content">
		<a href="https://blog.csdn.net/huanglong8/article/details/53837822" target="_blank" title="MySQL中MyISAM文件损坏时的一种修复方法">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>中<em>MyISAM</em>文件损坏时的一种修复方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-23</span>
				<span class="read-num hover-hide">
					阅读数 
					1553</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/huanglong8/article/details/53837822" target="_blank" title="MySQL中MyISAM文件损坏时的一种修复方法">
				<span class="desc oneline">这里以Navicat应用做为工具。MySQL在新建表时，在选项一栏会选择引擎，有很多种，关于每种的意义，大家可以自己查。默认是Innodb，但是我们项目中使用的是MyISAM，所以这里仅介绍MyISA...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/huanglong8">来自：	<span class="blog_title"> 黄黄臭臭的便便到铜钱</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_64" data-pid="64" data-track-view='{"mod":"kp_popu_64-1060","con":",,"}' data-track-click='{"mod":"kp_popu_64-1060","con":",,"}' data-report-view='{"mod":"kp_popu_64-1060","keyword":""}' data-report-click='{"mod":"kp_popu_64-1060","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/235?positionId=64&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/ma15732625261/article/details/82050510","strategy":"BlogCommendFromBaidu","index":"29"}'>
	<div class="content">
		<a href="https://blog.csdn.net/ma15732625261/article/details/82050510" target="_blank" title="【高性能MySQL第3版】第8章 优化服务器设置 下（小半）停">
		<h4 class="text-truncate oneline">
				【高性能<em>MySQL</em>第3版】第8章 优化服务器设置 下（小半）停		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-25</span>
				<span class="read-num hover-hide">
					阅读数 
					56</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/ma15732625261/article/details/82050510" target="_blank" title="【高性能MySQL第3版】第8章 优化服务器设置 下（小半）停">
				<span class="desc oneline">8.5.2MyISAM的i/o配置myisam每次写操作后便把索引变更刷新磁盘1、使用locktable延迟写入直到解锁这些表，精确控制哪些写被延迟，何时2、delay_key_write也可延迟索引...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/ma15732625261">来自：	<span class="blog_title"> 星小丫头辰</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/jiazimo/article/details/8226164","strategy":"BlogCommendFromBaidu","index":"30"}'>
	<div class="content">
		<a href="https://blog.csdn.net/jiazimo/article/details/8226164" target="_blank" title="mysql错误：……is marked as crashed and should be repaired！突然断电引起">
		<h4 class="text-truncate oneline">
				<em>mysql</em>错误：……is marked as crashed and should be repaired！突然断电引起		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-26</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/jiazimo/article/details/8226164" target="_blank" title="mysql错误：……is marked as crashed and should be repaired！突然断电引起">
				<span class="desc oneline">表不能操作，错误代码145Table'.\v3x\v3x_user_message'ismarkedascrashedandshouldberepaired错误信息：org.springframewo...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/jiazimo">来自：	<span class="blog_title"> jiazimo的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/350245409","strategy":"BlogCommendFromBaidu","index":"31"}'>
	<a href="https://bbs.csdn.net/topics/350245409" target="_blank">
		<h4 class="text-truncate oneline">
				如何处理<em>mysql</em>中表损坏问题		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">12-25</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">在mysql中有一张表 “A_tab”~数据量大，系统时时刻刻的在往时面写数据库更改数据，这样就导致这张表经常的损坏了~结果只能重新删除再建，我想请教能有什么办法防止这种情况 吗？</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/392504254","strategy":"BlogCommendFromBaidu","index":"32"}'>
	<a href="https://bbs.csdn.net/topics/392504254" target="_blank">
		<h4 class="text-truncate oneline">
				帮忙查找docker 异常退出原因，&quot;ExitCode&quot;: 2		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">01-03</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">程序环境：go语言开发的程序，在docker里运行。，程序使用 kafka客户端获取指定topic消息， 使用 mongo 客户端连接 集群进行 数据库增删改查操作。 问题描述：程序有时候直接导致do</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/silyvin/article/details/79332879","strategy":"BlogCommendFromBaidu","index":"33"}'>
	<div class="content">
		<a href="https://blog.csdn.net/silyvin/article/details/79332879" target="_blank" title="MyISAM和InnoDB的主要区别和应用场景">
		<h4 class="text-truncate oneline">
				<em>MyISAM</em>和InnoDB的主要区别和应用场景		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-17</span>
				<span class="read-num hover-hide">
					阅读数 
					9956</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/silyvin/article/details/79332879" target="_blank" title="MyISAM和InnoDB的主要区别和应用场景">
				<span class="desc oneline">http://blog.csdn.net/aaa123524457/article/details/54375341主要区别：1).［事务］MyISAM是非事务安全型的，而InnoDB是事务安全型的，...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/silyvin">来自：	<span class="blog_title"> silyvin</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_65" data-pid="65" data-track-view='{"mod":"kp_popu_65-84","con":",,"}' data-track-click='{"mod":"kp_popu_65-84","con":",,"}' data-report-view='{"mod":"kp_popu_65-84","keyword":""}' data-report-click='{"mod":"kp_popu_65-84","keyword":""}'><div id="three_ad33" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad33",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/var_dz/article/details/53645514","strategy":"BlogCommendFromBaidu","index":"34"}'>
	<div class="content">
		<a href="https://blog.csdn.net/var_dz/article/details/53645514" target="_blank" title="mysql数据库引擎 MyISAM和 InnoDB区别">
		<h4 class="text-truncate oneline">
				<em>mysql</em>数据库引擎 <em>MyISAM</em>和 InnoDB区别		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-14</span>
				<span class="read-num hover-hide">
					阅读数 
					115</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/var_dz/article/details/53645514" target="_blank" title="mysql数据库引擎 MyISAM和 InnoDB区别">
				<span class="desc oneline">1、存储结构MyISAM：每个MyISAM在磁盘上存储成三个文件。第一个文件的名字以表的名字开始，扩展名指出文件类型。.frm文件存储表定义。数据文件的扩展名为.MYD(MYData)。索引文件的扩展...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/var_dz">来自：	<span class="blog_title"> var_dz的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/392159344","strategy":"BlogCommendFromBaidu","index":"35"}'>
	<a href="https://bbs.csdn.net/topics/392159344" target="_blank">
		<h4 class="text-truncate oneline">
				hibernate+JPA自动建表失败：Error executing DDL via JDBC Statement		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">04-22</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">INFO: HHH10001501: Connection obtained from JdbcConnectionAccess for (non-JTA) DDL execution was not</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/Jack__Frost/article/details/72904318","strategy":"BlogCommendFromBaidu","index":"36"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Jack__Frost/article/details/72904318" target="_blank" title="MySQL优化系列（五）--数据库存储引擎（主要分析对比InnoDB和MyISAM以及讲述Mrg_Myisam分表）">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>优化系列（五）--数据库存储引擎（主要分析对比InnoDB和<em>MyISAM</em>以及讲述Mrg_<em>Myisam</em>分表）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-30</span>
				<span class="read-num hover-hide">
					阅读数 
					6927</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Jack__Frost/article/details/72904318" target="_blank" title="MySQL优化系列（五）--数据库存储引擎（主要分析对比InnoDB和MyISAM以及讲述Mrg_Myisam分表）">
				<span class="desc oneline">学校里做的项目都是默认MySQL的InnoDB存储引擎，没有思考过为什么使用，也没思考过其优缺和其他数据库存储引擎。直到我去实习了，在学习优化的过程中，才发现自己很无知，知识很局限。为此做次弥补。文章...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Jack__Frost">来自：	<span class="blog_title"> Jack__Frost的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/xmt1139057136/article/details/87941698","strategy":"BlogCommendFromBaidu","index":"37"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xmt1139057136/article/details/87941698" target="_blank" title="MySQL 中 MyISAM 中的查询为什么比 InnoDB 快？">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> 中 <em>MyISAM</em> 中的查询为什么比 InnoDB 快？		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-18</span>
				<span class="read-num hover-hide">
					阅读数 
					1265</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xmt1139057136/article/details/87941698" target="_blank" title="MySQL 中 MyISAM 中的查询为什么比 InnoDB 快？">
				<span class="desc oneline">点击上方“业余草”，选择“置顶公众号”第一时间获取技术干货和业界资讯！哎呀，一年之计在于春啊。最近过完年了，微信群里有非常多的小伙伴在问我一下面试方面的问题。比如：有让我出题的，有让我推荐资料的，还有...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xmt1139057136">来自：	<span class="blog_title"> xmt1139057136的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_33543227/article/details/80548828","strategy":"BlogCommendFromBaidu","index":"38"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_33543227/article/details/80548828" target="_blank" title="如何查看mysql的默认引擎和修改mysql的引擎">
		<h4 class="text-truncate oneline">
				如何查看<em>mysql</em>的默认引擎和修改<em>mysql</em>的引擎		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-02</span>
				<span class="read-num hover-hide">
					阅读数 
					2285</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_33543227/article/details/80548828" target="_blank" title="如何查看mysql的默认引擎和修改mysql的引擎">
				<span class="desc oneline">一：使用showengines命令。二：修改mysql引擎用：default-storage-engine=MyISAM</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_33543227">来自：	<span class="blog_title"> qq_33543227的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_66" data-pid="66" data-track-view='{"mod":"kp_popu_66-87","con":",,"}' data-track-click='{"mod":"kp_popu_66-87","con":",,"}' data-report-view='{"mod":"kp_popu_66-87","keyword":""}' data-report-click='{"mod":"kp_popu_66-87","keyword":""}'><div id="three_ad38" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad38",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/aclay/article/details/8054253","strategy":"BlogCommendFromBaidu","index":"39"}'>
	<div class="content">
		<a href="https://blog.csdn.net/aclay/article/details/8054253" target="_blank" title="MyISAM InnoDB 发音(怎么读，读什么)">
		<h4 class="text-truncate oneline">
				<em>MyISAM</em> InnoDB 发音(怎么读，读什么)		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-09</span>
				<span class="read-num hover-hide">
					阅读数 
					4万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/aclay/article/details/8054253" target="_blank" title="MyISAM InnoDB 发音(怎么读，读什么)">
				<span class="desc oneline">mysql有两种数据库引擎一种是MyISAM,一种是InnoDB MyISAM发音为&quot;my-z[ei]m&quot;;InnoDB发音为&quot;in-no-db&quot;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/aclay">来自：	<span class="blog_title"> so true_interview /</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/350246745","strategy":"BlogCommendFromBaidu","index":"40"}'>
	<a href="https://bbs.csdn.net/topics/350246745" target="_blank">
		<h4 class="text-truncate oneline">
				<em>mysql</em> <em>myisam</em>与innodb哪个速度更快，优缺点又是什么		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">12-26</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">我也知道这两种引擎各有优缺点，但是还是不太明白，有路过的大神讲解下 什么情况下myisam速度快 什么情况下innodb速度快 什么情况下适合用myisam 什么情况下用innodb比较好</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_30730151/article/details/98624806","strategy":"BlogCommendFromBaidu","index":"41"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_30730151/article/details/98624806" target="_blank" title="mysql 中 myisam innodb 的区别">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 中 <em>myisam</em> innodb 的区别		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-23</span>
				<span class="read-num hover-hide">
					阅读数 
					1</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_30730151/article/details/98624806" target="_blank" title="mysql 中 myisam innodb 的区别">
				<span class="desc oneline">区别：1.InnoDB支持事务，MyISAM不支持，对于InnoDB每一条SQL语言都默认封装成事务，自动提交，这样会影响速度，所以最好把多条SQL语言放在begin和commit之间，组成一个事务；...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_30730151">来自：	<span class="blog_title"> weixin_30730151的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/rnZuoZuo/article/details/39454175","strategy":"BlogCommendFromBaidu","index":"42"}'>
	<div class="content">
		<a href="https://blog.csdn.net/rnZuoZuo/article/details/39454175" target="_blank" title="Mysql 存储引擎中InnoDB与Myisam的主要区别">
		<h4 class="text-truncate oneline">
				<em>Mysql</em> 存储引擎中InnoDB与<em>Myisam</em>的主要区别		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-21</span>
				<span class="read-num hover-hide">
					阅读数 
					513</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/rnZuoZuo/article/details/39454175" target="_blank" title="Mysql 存储引擎中InnoDB与Myisam的主要区别">
				<span class="desc oneline">1， 事务处理innodb支持事务功能，myisam不支持。Myisam的执行速度更快，性能更好。2，select,update,insert,delete操作MyISAM：如果执行大量的SELECT...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/rnZuoZuo">来自：	<span class="blog_title"> HAPP NEW JAVA</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_35642036/article/details/82820178","strategy":"BlogCommendFromBaidu","index":"43"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_35642036/article/details/82820178" target="_blank" title="MyISAM与InnoDB 的区别（9个不同点）">
		<h4 class="text-truncate oneline">
				<em>MyISAM</em>与InnoDB 的区别（9个不同点）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-23</span>
				<span class="read-num hover-hide">
					阅读数 
					1907</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_35642036/article/details/82820178" target="_blank" title="MyISAM与InnoDB 的区别（9个不同点）">
				<span class="desc oneline">区别：1.InnoDB支持事务，MyISAM不支持，对于InnoDB每一条SQL语言都默认封装成事务，自动提交，这样会影响速度，所以最好把多条SQL语言放在begin和commit之间，组成一个事务；...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_35642036">来自：	<span class="blog_title"> 张花生的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_67" data-pid="67" data-track-view='{"mod":"kp_popu_67-658","con":",,"}' data-track-click='{"mod":"kp_popu_67-658","con":",,"}' data-report-view='{"mod":"kp_popu_67-658","keyword":""}' data-report-click='{"mod":"kp_popu_67-658","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3573058",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div></div>
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/392461646","strategy":"BlogCommendFromBaidu","index":"44"}'>
	<a href="https://bbs.csdn.net/topics/392461646" target="_blank">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> InnerDB 和 <em>MyISAM</em> 引擎		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">10-15</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">1. InnerDB 和 MyISAM 引擎分别在什么时候用? 2. MyISAM只支持表锁, 不支持行锁, 那还支持并发处理吗?</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u012017783/article/details/80347113","strategy":"BlogCommendFromBaidu","index":"45"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u012017783/article/details/80347113" target="_blank" title="MySQL主要的两种存储引擎">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>主要的两种存储引擎		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-17</span>
				<span class="read-num hover-hide">
					阅读数 
					474</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u012017783/article/details/80347113" target="_blank" title="MySQL主要的两种存储引擎">
				<span class="desc oneline">一、MyISAMMysql5.5之前默认的存储引擎，特点如下:(1)不支持行锁，支持对所有表加锁(2)不支持事务(3)不支持外键(4)支持读取查询的同时，支持往表中插入新记录(5)支持延迟更新索引，极...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u012017783">来自：	<span class="blog_title"> ZCC的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/sunjinyan_1/article/details/81236288","strategy":"BlogCommendFromBaidu","index":"46"}'>
	<div class="content">
		<a href="https://blog.csdn.net/sunjinyan_1/article/details/81236288" target="_blank" title="MyISAM存储引擎优化">
		<h4 class="text-truncate oneline">
				<em>MyISAM</em>存储引擎优化		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-27</span>
				<span class="read-num hover-hide">
					阅读数 
					320</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/sunjinyan_1/article/details/81236288" target="_blank" title="MyISAM存储引擎优化">
				<span class="desc oneline">MyISAM存储引擎优化	索引缓存优化		多KeyCache的使用		KeyCache的Mutex问题		KeyCache预加载		NULL值对统计信息的影响		表读取缓存优化		并发优化		其他可以...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/sunjinyan_1">来自：	<span class="blog_title"> sunjinyan_1的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_34987437/article/details/82344933","strategy":"BlogCommendFromBaidu","index":"47"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_34987437/article/details/82344933" target="_blank" title="InnoDB和MyISAM">
		<h4 class="text-truncate oneline">
				InnoDB和<em>MyISAM</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-03</span>
				<span class="read-num hover-hide">
					阅读数 
					1208</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_34987437/article/details/82344933" target="_blank" title="InnoDB和MyISAM">
				<span class="desc oneline">文章摘自微信公众号架构师之路+自己的总结，作为学习笔记记录下来，如有侵权，联系必删 MySQL最常用的两个引擎：MyISAM和InnoDB两种引擎的差异：（1）如果对整表进行count(*)，由于在存...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_34987437">来自：	<span class="blog_title"> 雨伞下的龙猫的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/390374895","strategy":"BlogCommendFromBaidu","index":"48"}'>
	<a href="https://bbs.csdn.net/topics/390374895" target="_blank">
		<h4 class="text-truncate oneline">
				<em>Mysql</em> <em>MyISAM</em>数据库引擎发音		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">02-25</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">谁知道Mysql 中默认数据库存取引擎MyISAM的正确发音。</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_68" data-pid="68" data-track-view='{"mod":"kp_popu_68-654","con":",,"}' data-track-click='{"mod":"kp_popu_68-654","con":",,"}' data-report-view='{"mod":"kp_popu_68-654","keyword":""}' data-report-click='{"mod":"kp_popu_68-654","keyword":""}'><div id="three_ad48" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad48",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/cnds123/article/details/80700516","strategy":"BlogCommendFromBaidu","index":"49"}'>
	<div class="content">
		<a href="https://blog.csdn.net/cnds123/article/details/80700516" target="_blank" title="PHP项目的发布">
		<h4 class="text-truncate oneline">
				PHP项目的发布		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-15</span>
				<span class="read-num hover-hide">
					阅读数 
					5965</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/cnds123/article/details/80700516" target="_blank" title="PHP项目的发布">
				<span class="desc oneline">﻿﻿PHP项目的发布发布PHP代码，需要有Php的解析服务器，目前比较流行的是apache。在apache中Php项目部署很简单，只需将php项目放入Apache访问目录中就可以访问了。修改Apach...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/cnds123">来自：	<span class="blog_title"> cnds123的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
                <div class="recommend-item-box type_hot_word">
                                <div class="content clearfix">
                    <div class="word float-left">
                                                            <span>
                        <a href="https://edu.csdn.net/courses/o5329_s5330_k " target="_blank">
                        机器学习教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/courses/o280_s351_k " target="_blank">
                        Objective-C培训                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o7115_s388_l0_t " target="_blank">
                        交互设计视频教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/course/play/5599/104252 " target="_blank">
                        颜色模型                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o363_l0_t " target="_blank">
                        设计制作学习                    </a></span>
                                                            </div>
                </div>
                                                </div>
                            <div class="recommend-loading-box">
                <img src='https://csdnimg.cn/release/phoenix/images/feedLoading.gif'>
            </div>
            <div class="recommend-end-box">
                <p class="text-center">没有更多推荐了，<a href="https://blog.csdn.net/" class="c-blue c-blue-hover c-blue-focus">返回首页</a></p>
            </div>
        </div>
    </main>

    <aside>
	<div id="asideProfile" class="aside-box">
    <!-- <h3 class="aside-title">个人资料</h3> -->
    <div class="profile-intro d-flex">
        <div class="avatar-box d-flex justify-content-center flex-column">
            <a href="https://blog.csdn.net/u010672439">
              <img src="https://avatar.csdn.net/4/0/4/3_u010672439.jpg" class="avatar_pic">
                              <img src="https://g.csdnimg.cn/static/user-reg-year/1x/6.png" class="user-years">
                          </a>
            
        </div>
        <div class="user-info d-flex justify-content-center flex-column">
            <p class="name csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                <a href="https://blog.csdn.net/u010672439"  class="" id="uid">RedBloodyBody</a>
            </p>
                    </div>
                <div class="opt-box d-flex justify-content-center flex-column">
            <span  class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                                    <a class="btn btn-sm btn-red-hollow attention" id="btnAttent">关注</a>
                            </span>
        </div>
            </div>
    <div class="data-info d-flex item-tiling">
                <dl class="text-center" title="29">
                        <dt><a href="https://blog.csdn.net/redbloodbody?t=1">原创</a></dt>
            <dd><a href="https://blog.csdn.net/redbloodbody?t=1"><span class="count">29</span></a></dd>
                    </dl>
        <dl class="text-center" id="fanBox" title="3">
            <dt>粉丝</dt>
            <dd><span class="count" id="fan">3</span></dd>
        </dl>
        <dl class="text-center" title="4">
            <dt>喜欢</dt>
            <dd><span class="count">4</span></dd>
        </dl>
        <dl class="text-center" title="3">
            <dt>评论</dt>
            <dd><span class="count">3</span></dd>
        </dl>
    </div>
    <div class="grade-box clearfix">
        <dl>
            <dt>等级：</dt>
            <dd>
                <a href="https://blog.csdn.net/home/help.html#level" title="3级,点击查看等级说明" target="_blank">
                    <svg class="icon icon-level" aria-hidden="true">
                        <use xlink:href="#csdnc-bloglevel-3"></use>
                    </svg>
                </a>
            </dd>
        </dl>
        <dl>
            <dt>访问：</dt>
            <dd title="23761">
                2万+            </dd>
        </dl>
        <dl>
            <dt>积分：</dt>
            <dd title="579">
                579            </dd>
        </dl>
        <dl title="129484">
            <dt>排名：</dt>
            <dd>12万+</dd>
        </dl>
    </div>
        <div class="badge-box d-flex">
        <span>勋章：</span>
        <div class="badge d-flex">
                                                        <div class="icon-badge" title="持之以恒">
                       <div class="mouse-box">
                          <img src="https://g.csdnimg.cn/static/user-medal/chizhiyiheng.svg" alt="">
                          <div class="icon-arrow"></div>
                       </div>
                       <div class="grade-detail-box">
                           <div class="pos-box">
                               <div class="left-box d-flex justify-content-center align-items-center flex-column">
                                    <img src="https://g.csdnimg.cn/static/user-medal/chizhiyiheng.svg" alt="">
                                   <p>持之以恒</p>
                               </div>
                               <div class="right-box">
                                   授予每个自然月内发布4篇或4篇以上原创或翻译IT博文的用户。不积跬步无以至千里，不积小流无以成江海，程序人生的精彩需要坚持不懈地积累！                               </div>
                           </div>
                       </div>
                   </div>
                                             </div>
        <script>
            (function ($) {
                setTimeout(function(){
                    $('div.icon-badge.show-moment').removeClass('show-moment');
                }, 5000);
            })(window.jQuery)
        </script>
    </div>
        <div class="personal-home-page"><a target="_blank"  href="https://me.csdn.net/u010672439">TA的个人主页 ></a></div>
</div>
<div class="csdn-tracking-statistics mb8 box-shadow" data-pid="blog" data-report-click='{"mod":"popu_4"}' data-report-view='{"mod":"popu_4"}' style="height:250px;">
    <div class="aside-content text-center" id="cpro_u2734133">
      <div id="kp_box_56" data-pid="56" data-track-view='{"mod":"kp_popu_56-76","con":",,"}' data-track-click='{"mod":"kp_popu_56-76","con":",,"}' data-report-view='{"mod":"kp_popu_56-76","keyword":""}' data-report-click='{"mod":"kp_popu_56-76","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3032528",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div>    </div>
</div>
<div id="asideArchive" class="aside-box flexible-box">
    <h3 class="aside-title">归档</h3>
    <div class="aside-content">
        <ul class="archive-list">
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010672439/article/month/2018/03">
                    2018年3月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010672439/article/month/2017/06">
                    2017年6月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010672439/article/month/2017/03">
                    2017年3月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010672439/article/month/2017/02">
                    2017年2月                    <span class="count float-right">8篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010672439/article/month/2016/11">
                    2016年11月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010672439/article/month/2015/11">
                    2015年11月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010672439/article/month/2015/10">
                    2015年10月                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010672439/article/month/2015/09">
                    2015年9月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010672439/article/month/2015/03">
                    2015年3月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010672439/article/month/2015/02">
                    2015年2月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010672439/article/month/2015/01">
                    2015年1月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010672439/article/month/2014/11">
                    2014年11月                    <span class="count float-right">6篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010672439/article/month/2014/07">
                    2014年7月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010672439/article/month/2014/03">
                    2014年3月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010672439/article/month/2013/09">
                    2013年9月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/u010672439/article/month/2013/08">
                    2013年8月                    <span class="count float-right">5篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideHotArticle" class="aside-box">
	<h3 class="aside-title">热门文章</h3>
	<div class="aside-content">
		<ul class="hotArticle-list csdn-tracking-statistics tracking-click" data-report-view='{"mod":"popu_521"}'>
							<li>

					<a href="https://blog.csdn.net/u010672439/article/details/58185240" >
                                                mysql介绍（myisam）                    </a>
					<p class="read">阅读数 <span>3411</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/u010672439/article/details/79602916" >
                                                Window下使用linux开发环境                    </a>
					<p class="read">阅读数 <span>1156</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/u010672439/article/details/11538301" >
                                                ５１自学网－专业培训老师录制的视频教程，让学习变得很轻松                    </a>
					<p class="read">阅读数 <span>999</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/u010672439/article/details/41115815" >
                                                thinkphp 删除表格最后一行                    </a>
					<p class="read">阅读数 <span>978</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/u010672439/article/details/41244617" >
                                                IE新发现                    </a>
					<p class="read">阅读数 <span>908</span></p>
				</li>
					</ul>
	</div>
</div>
<div id="asideNewComments" class="aside-box">
    <h3 class="aside-title">最新评论</h3>
    <div class="aside-content">
        <ul class="newcomment-list">
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/u010672439/article/details/49094701#comments">phpstorm xdebug 调...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/qq_31983651" class="user-name" target="_blank">qq_31983651：</a>赞                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/u010672439/article/details/41244617#comments">IE新发现</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/u010672439" class="user-name" target="_blank">u010672439：</a>话说，谁能给个解决办法？                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/u010672439/article/details/22399241#comments">php导入excel 到数据库</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/u010672439" class="user-name" target="_blank">u010672439：</a>phpexcelreader 下载地址http://sourceforge.net/projects/phpexcelreader/                </p>
            </li>
                    </ul>
    </div>
</div>
	<div id="asideFooter">
			
		<div class="aside-box">
			<div id="kp_box_57" data-pid="57" data-track-view='{"mod":"kp_popu_57-707","con":",,"}' data-track-click='{"mod":"kp_popu_57-707","con":",,"}' data-report-view='{"mod":"kp_popu_57-707","keyword":""}' data-report-click='{"mod":"kp_popu_57-707","keyword":""}'><script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- 博客内页左下视窗-20181130 -->
<ins class="adsbygoogle"
     style="display:inline-block;width:300px;height:250px"
     data-ad-client="ca-pub-1076724771190722"
     data-ad-slot="1894159733"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script></div>		</div>
				<div class="aside-box">
			<div class="persion_article">
			</div>
		</div>
	</div>
</aside>
<script src="https://csdnimg.cn/pubfooter/js/publib_footer-1.0.3.js" data-isfootertrack="false" type="text/javascript"></script>
<script>
	$("a.flexible-btn").click(function(){
		$(this).parents('div.aside-box').removeClass('flexible-box');
		$(this).remove();
	})
</script>
</div>
<div class="mask-dark"></div>
<div class="tool-box vertical">
    	<ul class="meau-list">
		<li class="btn-like-box ">
			<button class=" low-height hover-box btn-like " title="点赞">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup"></use>
				</svg>
				<span class="hover-show text-box text">
					<span class="no-active">点赞</span>
					<span class="active">取消点赞</span>
				</span>
				<p id="supportCount">0</p>
			</button>
		</li>
		<li class="to-commentBox">
						<a class="btn-comments low-height hover-box" title="写评论" href="#commentBox">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-comments"></use>
				</svg>
				<span class="hover-show text">评论</span>
				<p class="">
										</p>
			</a>
		</li>
		<li class="toc-container-box" id="liTocBox">
			<a class="btn-toc low-height hover-box btn-comments" title="目录">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-contents"></use>
				</svg>
				<span class="hover-show text">目录</span>
			</a>
			<div class="toc-container">
				<div class="pos-box">
					<div class="icon-arrow"></div>
					<div class="scroll-box">
						<div class="toc-box"></div>
					</div>
				</div>
				<div class="opt-box">
					<button class="btn-opt prev nomore" title="向上">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevronup"></use>
						</svg>
					</button>
					<button class="btn-opt next">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevrondown"></use>
						</svg>
					</button>
				</div>
			</div>
		</li>
		<li>
			<a class="btn-bookmark low-height hover-box btn-comments" title="收藏">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark"></use>
				</svg>
					<span class="hover-show text">收藏</span>
				<!-- <span class="hover-show text-box text">
					<span class="no-active">收藏</span>
					<span class="active">取消收藏</span>
				</span> -->
			</a>
		</li>
		<li class="bdsharebuttonbox">
			<div class="weixin-qr btn-comments low-height hover-box" >
        <a href="#" class="bds_weixin clear-share-style" data-cmd="weixin" title="手机看"></a>
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-usephone"></use>
				</svg>
				<span class="hover-show text text3">
					手机看
				</span>
			</div>
		</li>
							<li class="widescreen-hide">
				<a class="prev btn-comments low-height hover-box" href="https://blog.csdn.net/redbloodbody/article/details/57414326" title="LAMP服务器优化----PHP优化">
					<svg class="icon hover-hide" aria-hidden="true">
						<use xlink:href="#csdnc-chevronleft"></use>
					</svg>
					<span class="hover-show text text3">上一篇</span>
				</a>
			</li>
								<li class="widescreen-hide">
			<a class="next btn-comments hover-box low-height" href="https://blog.csdn.net/redbloodbody/article/details/58192130" title="LAMP服务器优化----mysql优化(myisam)">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-chevronright"></use>
				</svg>
				<span class="hover-show text text3">下一篇</span>
			</a>
		</li>
						<!-- 宽屏更多按钮 -->
		<li class="widescreen-more">
			<a class="btn-comments chat-ask-button low-height hover-box" title="快问" href="#chatqa">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-more"></use>
				</svg>
				<span class="hover-show text">更多</span>
				
			</a>
			<ul class="widescreen-more-box">
													<li class="widescreen-more">
						<a class="btn-comments low-height hover-box" href="https://blog.csdn.net/redbloodbody/article/details/57414326" title="LAMP服务器优化----PHP优化">
							<svg class="icon hover-hide" aria-hidden="true">
								<use xlink:href="#csdnc-chevronleft"></use>
							</svg>
							<span class="hover-show text text3">上一篇</span>
						</a>
					</li>
																<li class="widescreen-more">
					<a class="btn-comments hover-box low-height" href="https://blog.csdn.net/redbloodbody/article/details/58192130" title="LAMP服务器优化----mysql优化(myisam)">
						<svg class="icon hover-hide" aria-hidden="true">
							<use xlink:href="#csdnc-chevronright"></use>
						</svg>
						<span class="hover-show text text3">下一篇</span>
					</a>
				</li>
							</ul>
		</li>
	</ul>
</div>
<script>window._bd_share_config = { "common": { "bdSnsKey": {}, "bdText": "", "bdMini": "1", "bdMiniList": false, "bdPic": "", "bdStyle": "0", "bdSize": "16" }, "share": {} }; with (document) 0[(getElementsByTagName('head')[0] || body).appendChild(createElement('script')).src = 'https://csdnimg.cn/static/api/js/share.js?v=89860594'];</script>
<script src="https://g.csdnimg.cn/collection-box/1.0.0/collection-box.js?t=20190710173809" type="text/javascript"></script><script>
    var recommendCount = 50;
    recommendCount = recommendCount > 1 ? (recommendCount + (recommendCount>6 ? 2 : 1)) : recommendCount;
    var ChannelId = 16;
    var articleId = "58185240";
    var commentscount = 0;
    var islock = false;
    var curentUrl = "https://blog.csdn.net/redbloodbody/article/details/58185240";
    var myUrl = "https://my.csdn.net/";
    //1禁止评论，2正常
    var commentAuth = 2;
    //百度搜索
    var baiduKey = "mysql介绍（myisam） - RedBloodyBodys Blog";
    var needInsertBaidu = true;
    // 代码段样式
    var codeStyle = '';
	var highlight = ["mysql","\u4ecb\u7ecd","myisam"];//高亮数组

    var RecommendBlogExpertList = [];
	var articleType = 1;
	var CopyrightContent = '本文为博主原创文章，未经博主允许不得转载。';
</script>
<script src="https://csdnimg.cn/public/sandalstrap/1.4/js/sandalstrap.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-3d3b805766.js"></script>


<div style="display:none;">
	<img src="" onerror='setTimeout(function(){if(!/(csdn.net|iteye.com|baiducontent.com|googleusercontent.com|360webcache.com|sogoucdn.com|bingj.com|baidu.com)$/.test(window.location.hostname)){window.location.href="\x68\x74\x74\x70\x73\x3a\x2f\x2f\x77\x77\x77\x2e\x63\x73\x64\x6e\x2e\x6e\x65\x74"}},3000);'>
</div>
</body>

	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/codesnippet/lib/highlight/styles/atom-one-light.css">
	<script type="text/javascript" src="https://csdnimg.cn/release/phoenix/production/pc_wap_common-f868939e52.js" /></script>

<script src="https://csdnimg.cn/release/phoenix/template/js/common-37b7aadaf4.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/template/js/detail-1e5a65cde8.min.js"></script>

	<script src="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-fc7383b956.min.js"></script>
<script>
 // 全局声明
 if (window.csdn === undefined) {
      window.csdn = {};
    }
    window.csdn.sideToolbar = {
        options: {
            report:{
                isShow: true,
            },
            afterFinished: function(){
                setTimeout(function () {
                    var viphtml = '<a class="option-box" data-type="vip" href="https://mall.csdn.net/vip" target="_blank">'+
                        '<img src="https://g.csdnimg.cn/side-toolbar/1.4/images/vip.png" alt="" srcset="">'+
                        '<span class="show-txt">VIP<br>免广告</span>'+
                        '</a>';
                    $('.csdn-side-toolbar').prepend(viphtml)
                },300)
            }
        }
    }

    $(function(){
        $(document).on('click',"a.option-box[data-type='report']",function() {
            showReport(false,articleTitles)
        });
    })
</script>
<script src="https://g.csdnimg.cn/side-toolbar/1.4/side-toolbar.js"></script>

    <script src="//g.csdnimg.cn/??login-box/1.0.6/login-box.js,login-box/1.0.7/login-auto.js,copyright/1.0.3/copyright.js,baidu-search/1.0.0/baidu-search.js?t=20190307095522"  type="text/javascript"></script>

<script type="text/javascript" src="https://csdnimg.cn/release/blog_mathjax/MathJax.js?config=TeX-AMS-MML_HTMLorMML"></script>
<script type="text/x-mathjax-config">
    MathJax.Hub.Config({
            "HTML-CSS": {
                    linebreaks: { automatic: true, width: "94%container" },
                    imageFont: null
            },
            tex2jax: {
                preview: "none"
            },
            mml2jax: {
                preview: 'none'
            }
    });
</script>
<script type="text/javascript">
    </script>
<script src="https://gh.bdstatic.com/static/gh/js/sdk/bword.min.js"></script>
</html>
